Re: [GENERAL] translate "bug"?

Yeah, I've rethough about it and it does seem a bit out-there ;) ... I'm
sure there was one time where I encountered a situation where you would
want to use the \d? commands in an SQL statement environment but I can't
even begin to remember... so maybe it wasn't that important afterall and
regex'ing will do just fine.

I do feel though that the \df <regex> functionality would be useful in
other catalog queries (thank james, I didn't know that what they were
called) e.g. \do <regex> or \dt <regex> (which would get you all tables
containing <regex> e.g. titles, tileauthors, titleditors etc, as opposed to
\d titles which would get you just table titles).

or am I being dim again? [that dreaded feeling of posting something really
stupid...]

Cheers,

S.

>> >I realize you want it inside the psql program, but the above should get the
>> >same results pretty quick...james
>>
>> Thanks for that James... I've been trying to work out how to do it for ages!
>
>I will look into implementing \df kjasdf, and do it as a regex!


>
>>
>> I have to agree with Richard though, it would be very nice to have it
>> within psql.  Furthermore, it would be great if such functionality
>> could be extended to all \d? queries.  In fact, and I'm sure there actually
>> is a way to this if you're more knowledgeable than I, since most of these
>> \d? queries basically yield a 'SQL' table, wouldn't be nice to be able to
>> perform SQL on the  (e.g. select * from \df where function = 'int2_text';
>> etc.)
>>
>> Or am I just getting carried away! 8)
>
>That is a little strange.
>




+-------------------------+--------------------------------------+
| Stuart Rison            | Ludwig Institute for Cancer Research |
+-------------------------+ University College London            |
| Tel. (0171) 878 4041    | 91 Riding House Street               |
| Fax. (0171) 878 4040    | London, W1P 8BT, UNITED KINGDOM.     |
+-------------------------+--------------------------------------+
| stuart@NOJUNK_ludwig.ucl.ac.uk [Remove NOJUNK_ for it to work] |
+----------------------------------------------------------------+